USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[DestructionsInsert]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.DestructionsInsert
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 08/29/08
-- Description:	Destructions Table Insert
-- =============================================
CREATE PROCEDURE DestructionsInsert


           @DestructionId int,
           @DestructionTime datetime,
           @Attacker_PlayerId varchar(30),
           @Victim_PlayerId varchar(30),
           @MapId int,
           @RoundId int,
           @MiniRoundId int,
           @WeaponId int,
           @LogId int,
           @DateTime datetime
	

AS
BEGIN

INSERT INTO [Destructions]
           ([DestructionId]
           ,[DestructionTime]
           ,[Attacker_PlayerId]
           ,[Victim_PlayerId]
           ,[MapId]
           ,[RoundId]
           ,[MiniRoundId]
           ,[WeaponId]
           ,[LogId]
           ,[DateTime])
     VALUES
           (@DestructionId,
           @DestructionTime,
           @Attacker_PlayerId,
           @Victim_PlayerId,
           @MapId,
           @RoundId,
           @MiniRoundId,
           @WeaponId,
           @LogId,
           @DateTime)
END
GO
